"use strict";
const { Model } = require("sequelize");
const moment = require("moment/moment");
moment.locale("zh-cn");
module.exports = (sequelize, DataTypes) => {
  class Course extends Model {
    /**
     * Helper method for defining associations.
     * This method is not a part of Sequelize lifecycle.
     * The `models/index` file will call this method automatically.
     */
    static associate(models) {
      // define association here

      models.Course.belongsTo(models.Category, {
        as: "category", // 添加别名
      });
      models.Course.belongsTo(models.User, {
        as: "user", // 添加别名
      });
    }
  }
  Course.init(
    {
      categoryId: {
        type: DataTypes.INTEGER,
        allowNull: false,
        validate: {
          notNull: {
            msg: "分类ID必须填写",
          },
          notEmpty: {
            msg: "分类ID不能为空",
          },
          async isPresent(value) {
            const category = await sequelize.models.Category.findByPk(value);
            if (!category) {
              throw new Error(`ID为:${value}的分类不存在`);
            }
          },
        },
      },
      userId: {
        type: DataTypes.INTEGER,
        allowNull: false,
        validate: {
          notNull: {
            msg: "用户ID必须填写",
          },
          notEmpty: {
            msg: "用户ID不能为空",
          },
          async isPresent(value) {
            const user = await sequelize.models.User.findByPk(value);
            if (!user) {
              throw new Error(`ID为:${value}的用户不存在`);
            }
          },
        },
      },
      name: {
        type: DataTypes.STRING,
        allowNull: false,
        validate: {
          notNull: {
            msg: "课程名称必须填写",
          },
        },
      },
      image: {
        type: DataTypes.STRING,
        allowNull: false,
        validate: {},
      },
      recommended: DataTypes.BOOLEAN,
      introductiory: DataTypes.BOOLEAN,
      content: DataTypes.TEXT,
      likesCount: DataTypes.INTEGER,
      chaptersCount: DataTypes.INTEGER,
      createdAt: {
        type: DataTypes.DATE,
        get() {
          return moment(this.getDataValue("createdAt")).format("LL");
        },
      },
      updatedAt: {
        type: DataTypes.DATE,
        get() {
          return moment(this.getDataValue("updatedAt")).format("LL");
        },
      },
    },
    {
      sequelize,
      modelName: "Course",
    }
  );
  return Course;
};
